﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace FortuneHeavenCommon.DataMap
{
    public partial class DeliveryAddress
    {
        public const string TABLE_NAME = "DeliveryAddress";
        public const string INSERT_SQL = "insert into DeliveryAddress([ID],[UserID],[DeliverAddress],[No],[PhoneNumber],[DeliverType],[RecieveType],[MobileNumber],[IsValid],ContactUserName,Province,City) values (@ID,@UserID,@DeliverAddress,@No,@PhoneNumber,@DeliverType,@RecieveType,@MobileNumber,@IsValid,@ContactUserName,@Province,@City)";
        public const string UPDATE_SQL = "UPDATE DeliveryAddress  set  [ID] = @ID , [UserID] = @UserID , [DeliverAddress] = @DeliverAddress , [No] = @No , [PhoneNumber] = @PhoneNumber , [DeliverType] = @DeliverType , [RecieveType] = @RecieveType , [MobileNumber] = @MobileNumber , [IsValid] = @IsValid where ID = @ID ";
        /// <summary>
        ///
        /// </summary>
        public int ID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int UserID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string DeliverAddress
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string No
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string PhoneNumber
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int DeliverType
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int RecieveType
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string MobileNumber
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int IsValid
        {
            get;
            set;
        }

        public string ContactUserName
        {
            get;
            set;
        }

        public string Province
        {
            get;
            set;
        }

        public string City
        {
            get;
            set;
        }
    }

}
